INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'DATAMINE_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'IPM_FILE_COPY'));
 
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FILE_COPY'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'DS_RELI_FILE_COPY'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'MODALITY_RELI_FILE_COPY'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FILE_COPY'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'DS_RELI_FILE_COPY'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'MODALITY_RELI_FILE_COPY'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEMALARM_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'FILL_NOTIFICATION_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'STUCK_FILL_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'STUCK_UNBLANK_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ABANDONED_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'QUENCH_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'COMPRESSOR_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'METERERROR_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'LATCHEDDATA_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT'));

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP (
   RELATION_ID, PARENT_ID, CHILD_ID) 
VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextval,
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'),
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'NOTIFY'));

commit;